UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D467rU1uBJAn864PcWHlYrh2H0j2/wQ8GygsiM8bChg='
WHERE
key_id = '3b3646fb5fa777abf54d7775f2653264c2b586a9c605f5e4d85dcb6014f83626'
AND (
token = 'D467rU1uBJAn864PcWHlYrh2H0j2/wQ8GygsiM8bChg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)