UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9uloqD+R911jyF90m1EIFbPBRZzgt8/pUB8APdDARo='
WHERE
key_id = '6bc2ea447f03f25eb1f7037561df84343270fd312ca393aa1cfee8e96dd3f6fa'
AND (
token = 'R9uloqD+R911jyF90m1EIFbPBRZzgt8/pUB8APdDARo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)