UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQgg8IjAwUXLPdHCynh/c4FmdOqMa9p8taRkj2etkBM='
WHERE
key_id = 'ee2747b942cc975503cc25e0047a8c0e9be594ef28db454c0c4c0af7476ecb6f'
AND (
token = 'nQgg8IjAwUXLPdHCynh/c4FmdOqMa9p8taRkj2etkBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)