UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CPBcgwQ+SHheEnPJAVrKgTN2KZuAhgC4V7bj0NZwn/k='
WHERE
key_id = 'aceae4605afd4358b51f4a0ff60398c366d9053ed2672cc585e931cc0e5783a9'
AND (
token = 'CPBcgwQ+SHheEnPJAVrKgTN2KZuAhgC4V7bj0NZwn/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)