UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bfu67r1MS/mqP5BvkXPH8/FGdhyMy9Kn0Adr1EHAig8='
WHERE
key_id = 'b6c11267d0f2f9c279e28029ccacdb993afd5c71c9fe9325551b194a2a7ab6c2'
AND (
token = 'bfu67r1MS/mqP5BvkXPH8/FGdhyMy9Kn0Adr1EHAig8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)