UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LNdMZG9NBt9PdNNau8IThQbFB8DTAssK2B+ll1Giurg='
WHERE
key_id = '1b7a58fca577900abaea296d2234230ca73cc92a8ff332012394ac09974da64a'
AND (
token = 'LNdMZG9NBt9PdNNau8IThQbFB8DTAssK2B+ll1Giurg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)