UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PmbWhYKOWR48r0rCayC0pBuSMk7Xk3wIh9NicvTicxc='
WHERE
key_id = '80541cc69e7173c2218f74882e7a3b3fe1a5c6b09af3303f0ddc60fe8ef30a20'
AND (
token = 'PmbWhYKOWR48r0rCayC0pBuSMk7Xk3wIh9NicvTicxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)