UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bpbg+ROzZ6jLBgYn4aJTtBUFFMKz96RRL2zUsE1b9lE='
WHERE
key_id = 'e2edf9279a3a7019ad29e7e9742fb837ca5bb8f07c9be40f56a7ef28d8271276'
AND (
token = 'bpbg+ROzZ6jLBgYn4aJTtBUFFMKz96RRL2zUsE1b9lE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)