UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0A0WQ7veQMc4HC5j3CgyrTpJLWLaZdKbIE0OdAIeoOs='
WHERE
key_id = '579acf48c01da901ac41b4993737295e642a9147fe83c128213a517e803e19d1'
AND (
token = '0A0WQ7veQMc4HC5j3CgyrTpJLWLaZdKbIE0OdAIeoOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)