UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pC1K+Pf7+YKJvBb/zHbpLHoxbQB1ACIoGX3EwA3HWqc='
WHERE
key_id = '7790c90899db34ae77231b34fecabaee08141c1b73eb54521153c4b6e7815d7c'
AND (
token = 'pC1K+Pf7+YKJvBb/zHbpLHoxbQB1ACIoGX3EwA3HWqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)