UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ZnPK464FtgOqccP0lPu/+Mkce2W/9E3SYHzL/QcWVA='
WHERE
key_id = '26d1354b127e42422b5131a232e5519da0a7986aad053129871df52ef240acab'
AND (
token = '8ZnPK464FtgOqccP0lPu/+Mkce2W/9E3SYHzL/QcWVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)