UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a9YhSDZMoRrufuT5USD+7vdA2taFWprRyAW5zgyGjmY='
WHERE
key_id = '6d0dd3126c644490f4d57796ec2b42d102c0b212141eefe2daa1128339b39513'
AND (
token = 'a9YhSDZMoRrufuT5USD+7vdA2taFWprRyAW5zgyGjmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)