UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5f1zVaDkeMLzOHUztcOQJ2EQe1q7U/f0B037k6L4GQI='
WHERE
key_id = '3783f1d2d2ed04eef80a6731f723100c9ad30de9692d9932790ce710ece243ac'
AND (
token = '5f1zVaDkeMLzOHUztcOQJ2EQe1q7U/f0B037k6L4GQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)