UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U/YmdRox8HISsqsInPon7lmfCz11GpUU7wnVEfn314s='
WHERE
key_id = 'f861b47a41a566b3b7bbb7eb1db001640b61e59f56b7cd5d4b9a3b6af22b5214'
AND (
token = 'U/YmdRox8HISsqsInPon7lmfCz11GpUU7wnVEfn314s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)