UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'szPGi84l+0jquq+QQfU4+CAZvTizl/bMcxiPKKJ0Phg='
WHERE
key_id = 'ca196c68e89f5d6c21a89e39a7a07630c2a5a259999ea03e7d923a7a98472f7a'
AND (
token = 'szPGi84l+0jquq+QQfU4+CAZvTizl/bMcxiPKKJ0Phg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)