UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qaeFo1168WrQz8ng+AxkhbBHWtBCEHKZe2+zj1QX9gE='
WHERE
key_id = '0378b4e8b49c1329082c3747b44f6b47f70e672a19cc22d5bdab31e71d5b8e37'
AND (
token = 'qaeFo1168WrQz8ng+AxkhbBHWtBCEHKZe2+zj1QX9gE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)