UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8bG5XBFrL87/P2rSR1sx62WvVE3mtebnOE9Y3v1JQOk='
WHERE
key_id = 'c7cae111eda0629102b016dd24aa61afff20bf371b8ec3ded49ca3385efcbff7'
AND (
token = '8bG5XBFrL87/P2rSR1sx62WvVE3mtebnOE9Y3v1JQOk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)