UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6cw1wAi5xdQoyrA7xyWSPCsBiUTVAwNCHy6/XKxiJTA='
WHERE
key_id = 'a5f0275b1019bb52a47eb99cf369d28bc2e1718ab89daa967911e883b6df6faf'
AND (
token = '6cw1wAi5xdQoyrA7xyWSPCsBiUTVAwNCHy6/XKxiJTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)