UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l1oip0gK3gF0XECLCNBSurPxrPkYyAyh9+W+MFweI3s='
WHERE
key_id = '481578f2acc30d552237282718058e517b5697512a77ce855064baa42bd2bd75'
AND (
token = 'l1oip0gK3gF0XECLCNBSurPxrPkYyAyh9+W+MFweI3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)