UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kYqDIax8og3NS8yD4enL+jc5H4v1FyMT4g1IZoMKb8M='
WHERE
key_id = 'ea25692a4dd68b2291175f88fb5a65d2b199e3973f41c47f5f2bc5e39c224f7d'
AND (
token = 'kYqDIax8og3NS8yD4enL+jc5H4v1FyMT4g1IZoMKb8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)