UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yJUAmR95VpAyCQgZVySy1uutoj55Y3IiCP8zZ/k8RRE='
WHERE
key_id = 'c1d8b57adbeb50c5c7b019e18c28d7f506158522eb69c4021eb4c0f58127af49'
AND (
token = 'yJUAmR95VpAyCQgZVySy1uutoj55Y3IiCP8zZ/k8RRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)