UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5/gA1Dgn2I9iVIZJC5n7mLI1KqgBBWUHsvykwm1CpZk='
WHERE
key_id = 'dd4bc47631a9c5f243bc6eef845a8f8780a64bb3280ef53098466377007c0f61'
AND (
token = '5/gA1Dgn2I9iVIZJC5n7mLI1KqgBBWUHsvykwm1CpZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)