UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8yOUkVmgcQBIAHTbFoS07M+3hZfJFmDWq3bifHTTxIk='
WHERE
key_id = '0fda251f80396c12e19d30c87619495e4e884fb07bd84521af496073d92275b0'
AND (
token = '8yOUkVmgcQBIAHTbFoS07M+3hZfJFmDWq3bifHTTxIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)