UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FXOtsxHbXSIz8xogTwnJ9ZfCT5V794cocmTOG98GsaM='
WHERE
key_id = 'e47184f0779b007a0686fd4b2784ac3304c637a3277509363ca73db747f6d01b'
AND (
token = 'FXOtsxHbXSIz8xogTwnJ9ZfCT5V794cocmTOG98GsaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)