UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Sob8Rva8+qwblzZ7xkqI8UGfwf0tS01Tg3PtENJqoc='
WHERE
key_id = '3dcd1ba5d56b4016c93f2243c4e594d7b362a9bc4d299b363735b97cac07a8ba'
AND (
token = '0Sob8Rva8+qwblzZ7xkqI8UGfwf0tS01Tg3PtENJqoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)