UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HRWQ6n02KWMxce8W8uBPhM2+VzL6gSV+WPP/a0mg77w='
WHERE
key_id = '6b227f2a02e6e382e6f87e503397957f574227a1d47b463b43c49f0e09dd4eee'
AND (
token = 'HRWQ6n02KWMxce8W8uBPhM2+VzL6gSV+WPP/a0mg77w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)