UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPUbe1UPkygrvLzxzcbzlmItu1yIF62gHmPtx1L/vWo='
WHERE
key_id = '83c0d1d27e627877c7fbf964a3a12d6e7e117c3758bd67709a9926652426a842'
AND (
token = 'XPUbe1UPkygrvLzxzcbzlmItu1yIF62gHmPtx1L/vWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)