UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3sHQwUf8GCWC5s2+tncWNsAtSO8xZ4HSBmGRol9lZxI='
WHERE
key_id = '58636690d7a0585d4831ae5daf7ce29327d84f80c13560aa40056466a365a073'
AND (
token = '3sHQwUf8GCWC5s2+tncWNsAtSO8xZ4HSBmGRol9lZxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)