UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bzGFcRYZ81v6/8i8RPeUFsRvlHL5lma57clirAsWN0c='
WHERE
key_id = '7653a82fdf84a9dd3ab4f84c6e47496f59b1531587f977ccf3b959591c3cf555'
AND (
token = 'bzGFcRYZ81v6/8i8RPeUFsRvlHL5lma57clirAsWN0c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)