UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jX6tbOuBcFlhEGzvrfQGBS9LzPl22Hu/U16xxwnydEI='
WHERE
key_id = 'c3ffdc39e5b65355d1ab93d145e4a0bd43ad8696a78fce3a14fd6e32768d20d9'
AND (
token = 'jX6tbOuBcFlhEGzvrfQGBS9LzPl22Hu/U16xxwnydEI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)